www.loanperformer.com

Table of Contents (Online Help)

Repayment of Written-off Loans Report

This window will enable you to generate a report about repayments of written-off loans.

How to view the repayment of written-off loans report

To view the repayment of written-off loans report you go to Loans/Portfolio Reports/Reports on Repayments/Repayment of Written-off Loans A screen that looks as follows will appear:

The bookings that will be made after loan provisioning, loan write-off and Repayment of Written-off Loans Report will be as follows:

At loan provisioning

Provision costs for bad loans account	Debit
Provision for bad loans		Credit

At loan write-off

Provision for bad loans	Debit
Loans written of accounts		Credit

At repayment of written off loans

Cash/bank	Debit
Recovery of loans written off accounts		Credit

How to view the repayment of written-off loans report

To view the repayment of written-off loans report you go to Loans/Portfolio Reports/Reports on Repayments/Repayment of Written-off Loans A screen that looks as follows will appear:

• Report date from:  In the drop down box, select the date from when the report should start e.g. "01/09/2020" and in to drop down box select the date when the report should end e.g., "30/09/2020".
• Only repayments of written-off loans before the write-off date:  When this option is selected, the report to be generated will show only those payments that were made before the date when the loans were written off.
• Only repayments of written-off loans after write-off date:  When this option is selected, the report will show all repayments that were made after the loan was written off.
• Show each repayment (otherwise totals per loan):  When this option is selected, the report generated will display all the repayments that were made by an individual or group. If not ticked then the total figures will be shown against the client’s name.

• Report Currency: From the drop down list select the currency in which the report should appear, e.g., "UGX".

Note that Loan Performer offers the flexibility of displaying the report in different currencies.

• Branch Code:  From the drop down box, select the branch for which the  repayment of written-off loans report should be generated or tick the For all option to generate the report for all branches.

• Credit Officer:  Select from the drop down box a particular credit officer whom you want to generate a report about, this may be to see the arrears report for clients who were handled by that officer selected. In the example, the "For all" option is checked.
• Loan Fund: From the drop down box, select a particular Loan Fund that you want to generate a report about arrears, i.e. the loans whose repayments have been defaulted by clients that were got from a particular loan fund. The Loan Fund is set at menu System/Configuration/Funds. In the example, the "For all" option is checked.
• Geographical Area: From the drop down box, you can select to generate an arrears report basing on the actual locations of the clients. For example Districts, County, Sub-County and Parish as specified in your settings under Menu Support Files/Geographical Area's. In the example in the first screen of this page, the "For all" option is selected in order to have an arrears report for clients from all geographical areas.
• Loan Product: From the drop down box, select a loan Product that you want to generate a report about. The Loan product depends on what was set at Menu System/Configuration/Products. You may have Loan Products like School Fees Loans, Agricultural Loans etc. In the example above, the "For all" option is selected in order to have an arrears report for all Loan Products.
• Business Sector: From the drop down box, select a business sector for which you want to generate an arrears report. This can be Agriculture, Industry, Services or any other depending on what you set at menu Support files/Business Sector. In the example above, the "For all" option is selected to have an arrears report for all business sectors in the selected period.
• Grouping/Order: Select from the drop down box how the arrears report to be generated will be classified i.e. in the column title/heading. In the first screen on this page, client name is selected.
• Report Format: Select from the drop down box the sequence in which the column titles in your arrears report will appear.  In the first screen on this page, the first option is selected.
• Client Category 1: From the drop down box, select a client based on the classification that you made at menu Support Files/Client Category 1. In the example, the "For all" option is checked. The same applies for Client Category 2 and client Category 3.
• Loan Category 1: From the drop down box, select a classification of a loan that you made at Menu Support Files/Loan Category 1, it may have been a long term loan, short term loan etc. In the example, the "For all" option is checked. The same applies for Loan Category 2 and Loan Category 3.
• Guarantee Items: Select a class of items that were used as security for loans from the drop down box. These are set at menu Support Files/ Loan Guarantee Items.

• Select any other required additional options or use the default selections. For additional information on these options you can refer to Portfolio Report Formats.

• Additional filtering options?: This option is used to get a particular field or specification that you want. It helps you to narrow down the search for information that you need. When you check this option and click OK, a pop up screen will appear.  See below:

Select any other required additional options or use the default selections. For additional information on these options you can refer to Portfolio Report Formats.

Click on the OK to generate the written-off and rescheduled loans report that will look as follows:

• When "Show each repayment (otherwise totals per loan)" is not ticked then the total figures will be shown against the client’s name as seen below"

Click on the Close button to exit.

Related Topics

Contact LPF live support for more information
This service requires an Internet connection.